$sel=5;
include('conf.php');
// query per news selezionata
if($_GET["id"]!=""){
$sql2 = "SELECT * FROM contents WHERE id = '$_GET[id]' order by ordine ASC";
}
else {
$sql2 = "SELECT * FROM contents WHERE id_tipo = '2' and lang ='".$_SESSION["LANG"]."' and stato='1' order by ordine ASC limit 1";
}
$res2 = mysql_query($sql2);
$row2 = mysql_fetch_array($res2);
$sqlIMG1 = "SELECT * FROM images WHERE id_rif = '".$row2["id"]."' order by ordine ASC";
$rsIMG1 = mysql_query($sqlIMG1);
$img1_name = mysql_result($rsIMG1, 0, 'name');
$img2_name = mysql_result($rsIMG1, 1, 'name');
$img1 ="/timthumb/scripts/timthumb.php?src=".PREF."articms/admin/upImages/".$row2["id"]."/".$img1_name."&h=".$azienda_large_h."&w=".$azienda_large_w."&zc=".$azienda_large_resize;
$img2 ="/timthumb/scripts/timthumb.php?src=".PREF."articms/admin/upImages/".$row2["id"]."/".$img2_name."&h=".$azienda2_large_h."&w=".$azienda2_large_w."&zc=".$azienda2_large_resize;
?>
$sql3 = "SELECT * FROM contents WHERE id_tipo = '2' and lang ='".$_SESSION["LANG"]."' and stato='1' order by ordine ASC";
$res3 = mysql_query($sql3);
while($row3 = mysql_fetch_array($res3)){
if($row3["id"]==$row2["id"]){
echo "
// query per news
$sql1 = "SELECT * FROM contents WHERE id_tipo = '3' and lang ='".$_SESSION["LANG"]."' and stato='1' order by ordine ASC LIMIT 2";
$res1 = mysql_query($sql1);
while ($row1 = mysql_fetch_assoc($res1)) {
$sqlIMG = "SELECT * FROM images WHERE id_rif = '".$row1["id"]."' order by ordine ASC";
$rsIMG = mysql_query($sqlIMG);
$rowIMG = mysql_fetch_array($rsIMG);
$data = $row1["data_news"];
$anno = substr($data, 0,4);
$mese = substr($data, 5,2);
$giorno = substr($data, 8,2);
$row1["data_news"] = $giorno . ".".$mese .".".$anno;
?>